".substr($data1['start'],0,5)." Speaker: $data1[speaker] ($data1[univ_speaker])"; } if ($data1['speaker'] != '' && $data1['url_speaker'] =='') { echo "
  • ".substr($data1['start'],0,5)." Speaker: $data1[speaker] $data1[univ_speaker]
  • "; } if ($data1['titre'] != '') { echo "
  • Title: $data1[titre]
  • "; } } function event($day,$month,$year) { $nom_day=array('0'=>'Sunday','1'=>'Monday', '2'=>'Tuesday', '3'=>'Wednesday','4'=>'Thursday', '5'=>'Friday', '6'=>'Saturday'); /*****************lecture**********************/ $sql1="SELECT * FROM lecture WHERE DD=$day && MM=$month && YY=$year && pub=1 ORDER BY start "; mysql_query($sql1) or die (" ERREUR 00 calendar "); $result1 = mysql_query($sql1); while($data1=mysql_fetch_array($result1)) { echo""; } } /******************************************************************************/ /*********** EVENTS FOR DAY DD /*******************************************************************************/ require("../../openmydatabase.php"); $link = openmysqlserver(); $db = mysql_select_db($_database,$link) or die ("no link to the Center "); $see_day=trim($_GET['see_day']); $month=trim($_GET['month']); $year=trim($_GET['year']); $_SESSION['month']=$month; $_SESSION['year_ses']=$year; //echo "
    session prom $month,$year
    "; echo"
    EVENTS   FOR $see_day/$month/$year
    "; echo"
    ___________________________________________________________________________________________"; $year_short=$year-2000; event($see_day,$month,$year_short); //events,meeting,lectures events1($see_day,$month,$year_short); //workshop $today=date("z", mktime(0,0,0,date("m"),date("d"),date("Y")))+(date("y")-6)*365; $order_day=date("z", mktime(0,0,0,$month,$see_day,$year))+($year_short-6)*365; if($today<= $order_day) { $_SESSION['path_add']="FormNewEvent.php" ; $_SESSION['for_day']=$see_day; $_SESSION['for_month']=$month; $_SESSION['for_year']=$year; echo"
    "; echo"[Add event for $see_day/$month/$year]"; }?>
    [ Month view ]